Josef Jablonský A SPREADSHEET - BASED SYSTEM FOR DEA MODELS
نویسنده
چکیده
DEA models are tools for evaluation of efficiency and performance of decision making units. They are based on the definition of efficiency as the ratio of the sum of outputs produced by the unit divided by the sum of inputs spent in the production process. A standard LP solver is the only requirement for solving DEA models. Unfortunately specialized optimization packages are not available to typical users. In this case it is possible to use the built-in MS Excel solver. This solver has many limitations, but it is usually a sufficient tool for DEA models. The paper describes an original MS Excel add-on application that offers a simple tool for solving several standard DEA models. This application includes basic envelopment models with constant and variable returns to scale, SBM models, models with undesirable inputs and outputs and models with uncontrollable input and outputs. The application allows to calculate super-efficiency measures for most of the models mentioned. The functionality and main features of the system are illustrated by a simple case study – an evaluation of performance of pension funds in the Czech Republic.
منابع مشابه
Ranking Models in Data Envelopment Analysis
Traditional data envelopment analysis models split decision making units into two basic groups, efficient and inefficient. They are based on solving linear optimization problems and currently they represent very popular tool for efficiency and performance evaluation. Efficiency scores of inefficient units allows their ranking but efficient units cannot be ranked directly because of their maximu...
متن کاملA Ratio-Based Efficiency Measurement for Ranking Multi-Stage Production Systems in DEA
Conventional data envelopment analysis (DEA) models are used to measure efficiency score of production systems when they are considered as black boxes and their internal relationship is ignored. This paper deals with a common special case of network systems which is called multi-stage production system and can be generalized to many organizations. A multi stage production system has some stages...
متن کاملA hybrid decision making system using DEA and fuzzy models for supplier selection in the presence of multiple decision makers
متن کامل
Measuring Efficiency of Production Units by Ahp Models
The paper deals with models and methods for evaluation of efficiency of production units. The standard modeling approach for evaluation of efficiency is data envelopment analysis (DEA) based on the definition of efficiency as the ratio of outputs produced by the unit and inputs spent in the production process. Standard data envelopment analysis models divide the units into inefficient and effic...
متن کاملAllocation efficiency in network DEA
The present study is an attempt towards remodeling cost, revenue and profit relationship within the network process. The previous models of Data Envelopment Analysis (DEA) have been too general in their scope and focused on the input and the output within a black box system, therefore they have not been able to measure various phases simultaneously within a network system. By using these mod...
متن کامل